
package DataAccess;

import DomainModel.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;


/*
 *
 * @author Patrick
 */
public class ScheduleDA {
    private DBManager dbm;
    private Connection conn;
    private PreparedStatement prep;

    public ScheduleDA() throws Exception {
        conn = DBManager.getInstance().getConnection();
    }
/*    
    public List<Weekday> getAllWeekdays() throws SQLException {
        List<Weekday> weekdayList = new LinkedList<>();
        String query = "select * from weekdays";
        prep = conn.prepareStatement(query);
        ResultSet rs = prep.executeQuery();
        while (rs.next()) { 
            weekdayList.add(Weekday.getDayById(rs.getInt("id")));
         
        }
        return weekdayList;
    }
    * */
}
